Overview
Brought to you by YData
Dataset statistics
| Number of variables | 16 |
|---|---|
| Number of observations | 2372474 |
| Missing cells | 3 |
| Missing cells (%) | < 0.1% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 1.2 GiB |
| Average record size in memory | 565.3 B |
Variable types
| Text | 4 |
|---|---|
| Numeric | 7 |
| DateTime | 4 |
| Categorical | 1 |
Brand is highly overall correlated with Classification | High correlation |
Classification is highly overall correlated with Brand | High correlation |
Dollars is highly overall correlated with PurchasePrice and 1 other fields | High correlation |
PurchasePrice is highly overall correlated with Dollars | High correlation |
Quantity is highly overall correlated with Dollars | High correlation |
PurchasePrice is highly skewed (γ1 = 106.3858573) | Skewed |
Dollars is highly skewed (γ1 = 30.42890051) | Skewed |
Reproduction
| Analysis started | 2025-09-25 08:07:09.653548 |
|---|---|
| Analysis finished | 2025-09-25 08:09:42.708747 |
| Duration | 2 minutes and 33.06 seconds |
| Software version | ydata-profiling vv4.16.1 |
| Download configuration | config.json |
Variables
InventoryId
Text
| Distinct | 245907 |
|---|---|
| Distinct (%) | 10.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 149.4 MiB |
Length
| Max length | 22 |
|---|---|
| Median length | 21 |
| Mean length | 17.045803 |
| Min length | 6 |
Unique
| Unique | 56671 ? |
|---|---|
| Unique (%) | 2.4% |
Sample
| 1st row | 69_MOUNTMEND_8412 |
|---|---|
| 2nd row | 30_CULCHETH_5255 |
| 3rd row | 34_PITMERDEN_5215 |
| 4th row | 1_HARDERSFIELD_5255 |
| 5th row | 76_DONCASTER_2034 |
| Value | Count | Frequency (%) |
| 55_dry | 46820 | 1.9% |
| 56_beggar's | 30429 | 1.2% |
| 42_black | 18198 | 0.7% |
| 47_pella's | 14976 | 0.6% |
| 26_knife's | 3974 | 0.2% |
| 73_doncaster_8068 | 180 | < 0.1% |
| 73_doncaster_3545 | 178 | < 0.1% |
| 76_doncaster_1233 | 175 | < 0.1% |
| 76_doncaster_5364 | 174 | < 0.1% |
| 67_eanverness_3545 | 171 | < 0.1% |
| Other values (245902) | 2371596 |
Most occurring characters
| Value | Count | Frequency (%) |
| _ | 4744948 | 11.7% |
| E | 2562543 | 6.3% |
| R | 2140431 | 5.3% |
| 3 | 2050600 | 5.1% |
| N | 1902767 | 4.7% |
| A | 1771034 | 4.4% |
| 2 | 1702043 | 4.2% |
| 6 | 1688830 | 4.2% |
| 1 | 1665032 | 4.1% |
| 4 | 1625850 | 4.0% |
| Other values (25) | 18586646 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 40440724 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| _ | 4744948 | 11.7% |
| E | 2562543 | 6.3% |
| R | 2140431 | 5.3% |
| 3 | 2050600 | 5.1% |
| N | 1902767 | 4.7% |
| A | 1771034 | 4.4% |
| 2 | 1702043 | 4.2% |
| 6 | 1688830 | 4.2% |
| 1 | 1665032 | 4.1% |
| 4 | 1625850 | 4.0% |
| Other values (25) | 18586646 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 40440724 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| _ | 4744948 | 11.7% |
| E | 2562543 | 6.3% |
| R | 2140431 | 5.3% |
| 3 | 2050600 | 5.1% |
| N | 1902767 | 4.7% |
| A | 1771034 | 4.4% |
| 2 | 1702043 | 4.2% |
| 6 | 1688830 | 4.2% |
| 1 | 1665032 | 4.1% |
| 4 | 1625850 | 4.0% |
| Other values (25) | 18586646 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 40440724 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| _ | 4744948 | 11.7% |
| E | 2562543 | 6.3% |
| R | 2140431 | 5.3% |
| 3 | 2050600 | 5.1% |
| N | 1902767 | 4.7% |
| A | 1771034 | 4.4% |
| 2 | 1702043 | 4.2% |
| 6 | 1688830 | 4.2% |
| 1 | 1665032 | 4.1% |
| 4 | 1625850 | 4.0% |
| Other values (25) | 18586646 |
Store
Real number (ℝ)
| Distinct | 80 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 44.651328 |
| Minimum | 1 |
|---|---|
| Maximum | 81 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 18.1 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 6 |
| Q1 | 25 |
| median | 48 |
| Q3 | 67 |
| 95-th percentile | 76 |
| Maximum | 81 |
| Range | 80 |
| Interquartile range (IQR) | 42 |
Descriptive statistics
| Standard deviation | 23.512448 |
|---|---|
| Coefficient of variation (CV) | 0.52657892 |
| Kurtosis | -1.2139221 |
| Mean | 44.651328 |
| Median Absolute Deviation (MAD) | 20 |
| Skewness | -0.24595524 |
| Sum | 1.0593411 × 108 |
| Variance | 552.83521 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 76 | 121123 | 5.1% |
| 73 | 96794 | 4.1% |
| 38 | 93412 | 3.9% |
| 34 | 92113 | 3.9% |
| 66 | 82699 | 3.5% |
| 67 | 69419 | 2.9% |
| 50 | 65512 | 2.8% |
| 69 | 63683 | 2.7% |
| 60 | 58169 | 2.5% |
| 41 | 53344 | 2.2% |
| Other values (70) | 1576206 |
| Value | Count | Frequency (%) |
| 1 | 42370 | |
| 2 | 28056 | |
| 3 | 1806 | 0.1% |
| 4 | 14483 | 0.6% |
| 5 | 10441 | 0.4% |
| 6 | 39393 | |
| 7 | 31044 | |
| 8 | 23414 | |
| 9 | 33298 | |
| 10 | 41413 |
| Value | Count | Frequency (%) |
| 81 | 9407 | 0.4% |
| 79 | 28559 | 1.2% |
| 78 | 17544 | 0.7% |
| 77 | 22823 | 1.0% |
| 76 | 121123 | |
| 75 | 22356 | 0.9% |
| 74 | 40723 | 1.7% |
| 73 | 96794 | |
| 72 | 32784 | 1.4% |
| 71 | 25727 | 1.1% |
Brand
Real number (ℝ)
High correlation
| Distinct | 10664 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 12418.641 |
| Minimum | 58 |
|---|---|
| Maximum | 90631 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 18.1 MiB |
Quantile statistics
| Minimum | 58 |
|---|---|
| 5-th percentile | 1376 |
| Q1 | 3639 |
| median | 6523 |
| Q3 | 18877 |
| 95-th percentile | 40097 |
| Maximum | 90631 |
| Range | 90573 |
| Interquartile range (IQR) | 15238 |
Descriptive statistics
| Standard deviation | 12557.278 |
|---|---|
| Coefficient of variation (CV) | 1.0111636 |
| Kurtosis | 0.39302954 |
| Mean | 12418.641 |
| Median Absolute Deviation (MAD) | 3529 |
| Skewness | 1.2686906 |
| Sum | 2.9462903 × 1010 |
| Variance | 1.5768524 × 108 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 8068 | 7359 | 0.3% |
| 3893 | 7166 | 0.3% |
| 4261 | 6774 | 0.3% |
| 1233 | 6584 | 0.3% |
| 3405 | 6506 | 0.3% |
| 3512 | 6459 | 0.3% |
| 3243 | 6419 | 0.3% |
| 3246 | 6386 | 0.3% |
| 1376 | 6336 | 0.3% |
| 3545 | 6326 | 0.3% |
| Other values (10654) | 2306159 |
| Value | Count | Frequency (%) |
| 58 | 596 | |
| 60 | 97 | < 0.1% |
| 61 | 26 | < 0.1% |
| 62 | 567 | |
| 63 | 524 | |
| 70 | 3 | < 0.1% |
| 72 | 77 | < 0.1% |
| 75 | 1 | < 0.1% |
| 77 | 842 | |
| 79 | 496 |
| Value | Count | Frequency (%) |
| 90631 | 131 | |
| 90609 | 11 | < 0.1% |
| 90604 | 13 | < 0.1% |
| 90090 | 2 | < 0.1% |
| 90089 | 9 | < 0.1% |
| 90088 | 2 | < 0.1% |
| 90087 | 5 | < 0.1% |
| 90086 | 1 | < 0.1% |
| 90085 | 3 | < 0.1% |
| 90080 | 1 | < 0.1% |
Description
Text
| Distinct | 9652 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 158.2 MiB |
Length
| Max length | 29 |
|---|---|
| Median length | 23 |
| Mean length | 20.935902 |
| Min length | 6 |
Unique
| Unique | 1271 ? |
|---|---|
| Unique (%) | 0.1% |
Sample
| 1st row | Tequila Ocho Plata Fresno |
|---|---|
| 2nd row | TGI Fridays Ultimte Mudslide |
| 3rd row | TGI Fridays Long Island Iced |
| 4th row | TGI Fridays Ultimte Mudslide |
| 5th row | Glendalough Double Barrel |
| Value | Count | Frequency (%) |
| vodka | 267350 | 3.2% |
| svgn | 187706 | 2.2% |
| chard | 168648 | 2.0% |
| pnt | 136783 | 1.6% |
| cab | 134965 | 1.6% |
| rum | 131678 | 1.6% |
| cal | 109124 | 1.3% |
| grigio | 81848 | 1.0% |
| red | 76942 | 0.9% |
| black | 76733 | 0.9% |
| Other values (8173) | 7027497 |
Most occurring characters
| Value | Count | Frequency (%) |
| 6026961 | 12.1% | |
| a | 4116492 | 8.3% |
| e | 3571756 | 7.2% |
| o | 3118929 | 6.3% |
| r | 3055020 | 6.2% |
| n | 2627269 | 5.3% |
| i | 2501223 | 5.0% |
| l | 2379802 | 4.8% |
| t | 1627528 | 3.3% |
| s | 1486233 | 3.0% |
| Other values (65) | 19158671 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 49669884 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 6026961 | 12.1% | |
| a | 4116492 | 8.3% |
| e | 3571756 | 7.2% |
| o | 3118929 | 6.3% |
| r | 3055020 | 6.2% |
| n | 2627269 | 5.3% |
| i | 2501223 | 5.0% |
| l | 2379802 | 4.8% |
| t | 1627528 | 3.3% |
| s | 1486233 | 3.0% |
| Other values (65) | 19158671 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 49669884 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 6026961 | 12.1% | |
| a | 4116492 | 8.3% |
| e | 3571756 | 7.2% |
| o | 3118929 | 6.3% |
| r | 3055020 | 6.2% |
| n | 2627269 | 5.3% |
| i | 2501223 | 5.0% |
| l | 2379802 | 4.8% |
| t | 1627528 | 3.3% |
| s | 1486233 | 3.0% |
| Other values (65) | 19158671 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 49669884 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 6026961 | 12.1% | |
| a | 4116492 | 8.3% |
| e | 3571756 | 7.2% |
| o | 3118929 | 6.3% |
| r | 3055020 | 6.2% |
| n | 2627269 | 5.3% |
| i | 2501223 | 5.0% |
| l | 2379802 | 4.8% |
| t | 1627528 | 3.3% |
| s | 1486233 | 3.0% |
| Other values (65) | 19158671 |
Size
Text
| Distinct | 51 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 3 |
| Missing (%) | < 0.1% |
| Memory size | 121.7 MiB |
Length
| Max length | 10 |
|---|---|
| Median length | 5 |
| Mean length | 4.7696086 |
| Min length | 2 |
Unique
| Unique | 5 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | 750mL |
|---|---|
| 2nd row | 1.75L |
| 3rd row | 1.75L |
| 4th row | 1.75L |
| 5th row | 750mL |
| Value | Count | Frequency (%) |
| 750ml | 1208612 | |
| 1.75l | 593298 | |
| 1.5l | 229841 | 9.5% |
| 50ml | 74965 | 3.1% |
| 375ml | 70635 | 2.9% |
| 3l | 55911 | 2.3% |
| 5l | 53490 | 2.2% |
| liter | 47520 | 2.0% |
| pk | 20175 | 0.8% |
| 4 | 17504 | 0.7% |
| Other values (31) | 42774 | 1.8% |
Most occurring characters
| Value | Count | Frequency (%) |
| L | 2372127 | |
| 5 | 2239758 | |
| 7 | 1889830 | |
| m | 1385690 | |
| 0 | 1310135 | |
| 1 | 843312 | 7.5% |
| . | 823476 | 7.3% |
| 3 | 129884 | 1.1% |
| i | 47520 | 0.4% |
| t | 47520 | 0.4% |
| Other values (18) | 226506 | 2.0% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 11315758 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| L | 2372127 | |
| 5 | 2239758 | |
| 7 | 1889830 | |
| m | 1385690 | |
| 0 | 1310135 | |
| 1 | 843312 | 7.5% |
| . | 823476 | 7.3% |
| 3 | 129884 | 1.1% |
| i | 47520 | 0.4% |
| t | 47520 | 0.4% |
| Other values (18) | 226506 | 2.0% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 11315758 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| L | 2372127 | |
| 5 | 2239758 | |
| 7 | 1889830 | |
| m | 1385690 | |
| 0 | 1310135 | |
| 1 | 843312 | 7.5% |
| . | 823476 | 7.3% |
| 3 | 129884 | 1.1% |
| i | 47520 | 0.4% |
| t | 47520 | 0.4% |
| Other values (18) | 226506 | 2.0% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 11315758 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| L | 2372127 | |
| 5 | 2239758 | |
| 7 | 1889830 | |
| m | 1385690 | |
| 0 | 1310135 | |
| 1 | 843312 | 7.5% |
| . | 823476 | 7.3% |
| 3 | 129884 | 1.1% |
| i | 47520 | 0.4% |
| t | 47520 | 0.4% |
| Other values (18) | 226506 | 2.0% |
VendorNumber
Real number (ℝ)
| Distinct | 126 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 6886.4355 |
| Minimum | 2 |
|---|---|
| Maximum | 201359 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 18.1 MiB |
Quantile statistics
| Minimum | 2 |
|---|---|
| 5-th percentile | 653 |
| Q1 | 3252 |
| median | 4425 |
| Q3 | 9552 |
| 95-th percentile | 17035 |
| Maximum | 201359 |
| Range | 201357 |
| Interquartile range (IQR) | 6300 |
Descriptive statistics
| Standard deviation | 8066.6939 |
|---|---|
| Coefficient of variation (CV) | 1.1713889 |
| Kurtosis | 90.903897 |
| Mean | 6886.4355 |
| Median Absolute Deviation (MAD) | 3297 |
| Skewness | 7.9128421 |
| Sum | 1.6337889 × 1010 |
| Variance | 65071550 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 3960 | 243326 | 10.3% |
| 12546 | 189832 | 8.0% |
| 1392 | 185574 | 7.8% |
| 4425 | 176781 | 7.5% |
| 3252 | 162567 | 6.9% |
| 9552 | 112792 | 4.8% |
| 17035 | 107612 | 4.5% |
| 9815 | 106106 | 4.5% |
| 8004 | 92210 | 3.9% |
| 480 | 91846 | 3.9% |
| Other values (116) | 903828 |
| Value | Count | Frequency (%) |
| 2 | 13 | < 0.1% |
| 54 | 1 | < 0.1% |
| 60 | 626 | < 0.1% |
| 105 | 57 | < 0.1% |
| 200 | 8 | < 0.1% |
| 287 | 18 | < 0.1% |
| 388 | 266 | < 0.1% |
| 480 | 91846 | |
| 516 | 23510 | 1.0% |
| 653 | 11406 | 0.5% |
| Value | Count | Frequency (%) |
| 201359 | 1 | < 0.1% |
| 173357 | 153 | < 0.1% |
| 172662 | 149 | < 0.1% |
| 99166 | 41 | < 0.1% |
| 98450 | 1509 | |
| 90059 | 44 | < 0.1% |
| 90058 | 886 | |
| 90057 | 74 | < 0.1% |
| 90056 | 1393 | |
| 90053 | 231 | < 0.1% |
VendorName
Text
| Distinct | 129 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 170.9 MiB |
Length
| Max length | 39 |
|---|---|
| Median length | 27 |
| Mean length | 26.524408 |
| Min length | 10 |
Unique
| Unique | 5 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | ALTAMAR BRANDS LLC |
|---|---|
| 2nd row | AMERICAN VINTAGE BEVERAGE |
| 3rd row | AMERICAN VINTAGE BEVERAGE |
| 4th row | AMERICAN VINTAGE BEVERAGE |
| 5th row | ATLANTIC IMPORTING COMPANY |
| Value | Count | Frequency (%) |
| inc | 1119633 | 13.8% |
| brands | 399251 | 4.9% |
| america | 327160 | 4.0% |
| north | 297657 | 3.7% |
| company | 278913 | 3.4% |
| diageo | 255682 | 3.2% |
| usa | 248319 | 3.1% |
| 242464 | 3.0% | |
| wine | 216171 | 2.7% |
| beam | 189832 | 2.3% |
| Other values (226) | 4516330 |
Most occurring characters
| Value | Count | Frequency (%) |
| 20632582 | ||
| A | 4552799 | 7.2% |
| I | 4312189 | 6.9% |
| N | 4151688 | 6.6% |
| E | 3673966 | 5.8% |
| R | 3325475 | 5.3% |
| C | 3033633 | 4.8% |
| O | 2635301 | 4.2% |
| S | 2322172 | 3.7% |
| T | 2291543 | 3.6% |
| Other values (36) | 11997120 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 62928468 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 20632582 | ||
| A | 4552799 | 7.2% |
| I | 4312189 | 6.9% |
| N | 4151688 | 6.6% |
| E | 3673966 | 5.8% |
| R | 3325475 | 5.3% |
| C | 3033633 | 4.8% |
| O | 2635301 | 4.2% |
| S | 2322172 | 3.7% |
| T | 2291543 | 3.6% |
| Other values (36) | 11997120 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 62928468 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 20632582 | ||
| A | 4552799 | 7.2% |
| I | 4312189 | 6.9% |
| N | 4151688 | 6.6% |
| E | 3673966 | 5.8% |
| R | 3325475 | 5.3% |
| C | 3033633 | 4.8% |
| O | 2635301 | 4.2% |
| S | 2322172 | 3.7% |
| T | 2291543 | 3.6% |
| Other values (36) | 11997120 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 62928468 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 20632582 | ||
| A | 4552799 | 7.2% |
| I | 4312189 | 6.9% |
| N | 4151688 | 6.6% |
| E | 3673966 | 5.8% |
| R | 3325475 | 5.3% |
| C | 3033633 | 4.8% |
| O | 2635301 | 4.2% |
| S | 2322172 | 3.7% |
| T | 2291543 | 3.6% |
| Other values (36) | 11997120 |
PONumber
Real number (ℝ)
| Distinct | 5543 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 11040.937 |
| Minimum | 8106 |
|---|---|
| Maximum | 13661 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 18.1 MiB |
Quantile statistics
| Minimum | 8106 |
|---|---|
| 5-th percentile | 8503 |
| Q1 | 9761 |
| median | 11103 |
| Q3 | 12397 |
| 95-th percentile | 13436 |
| Maximum | 13661 |
| Range | 5555 |
| Interquartile range (IQR) | 2636 |
Descriptive statistics
| Standard deviation | 1565.3402 |
|---|---|
| Coefficient of variation (CV) | 0.14177603 |
| Kurtosis | -1.1281758 |
| Mean | 11040.937 |
| Median Absolute Deviation (MAD) | 1322 |
| Skewness | -0.076414296 |
| Sum | 2.6194335 × 1010 |
| Variance | 2450290 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 10936 | 6108 | 0.3% |
| 13487 | 5594 | 0.2% |
| 11300 | 5532 | 0.2% |
| 13597 | 5532 | 0.2% |
| 11191 | 5529 | 0.2% |
| 13392 | 5488 | 0.2% |
| 13226 | 5481 | 0.2% |
| 12149 | 5382 | 0.2% |
| 11028 | 5286 | 0.2% |
| 10260 | 5168 | 0.2% |
| Other values (5533) | 2317374 |
| Value | Count | Frequency (%) |
| 8106 | 368 | |
| 8107 | 2 | < 0.1% |
| 8108 | 585 | |
| 8109 | 67 | < 0.1% |
| 8110 | 571 | |
| 8111 | 2 | < 0.1% |
| 8112 | 38 | < 0.1% |
| 8113 | 91 | < 0.1% |
| 8114 | 72 | < 0.1% |
| 8115 | 111 | < 0.1% |
| Value | Count | Frequency (%) |
| 13661 | 2099 | |
| 13660 | 18 | < 0.1% |
| 13659 | 34 | < 0.1% |
| 13658 | 734 | < 0.1% |
| 13657 | 31 | < 0.1% |
| 13656 | 25 | < 0.1% |
| 13655 | 27 | < 0.1% |
| 13654 | 903 | < 0.1% |
| 13653 | 431 | < 0.1% |
| 13652 | 5088 |
PODate
Date
| Distinct | 319 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 18.1 MiB |
| Minimum | 2023-12-20 00:00:00 |
|---|---|
| Maximum | 2024-12-23 00:00:00 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
Histogram with fixed size bins (bins=50)
ReceivingDate
Date
| Distinct | 364 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 18.1 MiB |
| Minimum | 2024-01-01 00:00:00 |
|---|---|
| Maximum | 2024-12-31 00:00:00 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
Histogram with fixed size bins (bins=50)
InvoiceDate
Date
| Distinct | 373 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 18.1 MiB |
| Minimum | 2024-01-04 00:00:00 |
|---|---|
| Maximum | 2025-01-10 00:00:00 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
Histogram with fixed size bins (bins=50)
PayDate
Date
| Distinct | 382 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 18.1 MiB |
| Minimum | 2024-02-04 00:00:00 |
|---|---|
| Maximum | 2025-02-19 00:00:00 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
Histogram with fixed size bins (bins=50)
PurchasePrice
Real number (ℝ)
High correlation Skewed
| Distinct | 2151 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 12.05005 |
| Minimum | 0 |
|---|---|
| Maximum | 5681.81 |
| Zeros | 153 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 18.1 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 3.37 |
| Q1 | 6.12 |
| median | 9.22 |
| Q3 | 14.49 |
| 95-th percentile | 28.88 |
| Maximum | 5681.81 |
| Range | 5681.81 |
| Interquartile range (IQR) | 8.37 |
Descriptive statistics
| Standard deviation | 17.945104 |
|---|---|
| Coefficient of variation (CV) | 1.4892141 |
| Kurtosis | 22388.512 |
| Mean | 12.05005 |
| Median Absolute Deviation (MAD) | 3.51 |
| Skewness | 106.38586 |
| Sum | 28588431 |
| Variance | 322.02677 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 5.84 | 21743 | 0.9% |
| 7.93 | 18223 | 0.8% |
| 7.68 | 13385 | 0.6% |
| 9.62 | 13252 | 0.6% |
| 9.08 | 13191 | 0.6% |
| 10.38 | 13186 | 0.6% |
| 6.53 | 13163 | 0.6% |
| 6.75 | 12942 | 0.5% |
| 8.44 | 12857 | 0.5% |
| 4.79 | 12306 | 0.5% |
| Other values (2141) | 2228226 |
| Value | Count | Frequency (%) |
| 0 | 153 | < 0.1% |
| 0.36 | 533 | < 0.1% |
| 0.38 | 949 | < 0.1% |
| 0.39 | 1 | < 0.1% |
| 0.62 | 395 | < 0.1% |
| 0.64 | 61 | < 0.1% |
| 0.71 | 2909 | 0.1% |
| 0.72 | 10602 | |
| 0.73 | 999 | < 0.1% |
| 0.74 | 7543 |
| Value | Count | Frequency (%) |
| 5681.81 | 3 | < 0.1% |
| 4264.7 | 2 | < 0.1% |
| 3352.93 | 3 | < 0.1% |
| 2713.17 | 1 | < 0.1% |
| 2661.86 | 7 | < 0.1% |
| 2518.51 | 1 | < 0.1% |
| 2290.07 | 27 | |
| 2222.21 | 3 | < 0.1% |
| 2109.37 | 2 | < 0.1% |
| 1574.8 | 7 | < 0.1% |
Quantity
Real number (ℝ)
High correlation
| Distinct | 686 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 14.155846 |
| Minimum | 1 |
|---|---|
| Maximum | 3816 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 18.1 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 3 |
| Q1 | 6 |
| median | 10 |
| Q3 | 12 |
| 95-th percentile | 46 |
| Maximum | 3816 |
| Range | 3815 |
| Interquartile range (IQR) | 6 |
Descriptive statistics
| Standard deviation | 23.446162 |
|---|---|
| Coefficient of variation (CV) | 1.6562882 |
| Kurtosis | 759.02166 |
| Mean | 14.155846 |
| Median Absolute Deviation (MAD) | 4 |
| Skewness | 13.73724 |
| Sum | 33584377 |
| Variance | 549.72249 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 12 | 627805 | |
| 6 | 499448 | |
| 11 | 171280 | 7.2% |
| 5 | 160343 | 6.8% |
| 4 | 129921 | 5.5% |
| 10 | 99799 | 4.2% |
| 3 | 90988 | 3.8% |
| 24 | 57464 | 2.4% |
| 9 | 55971 | 2.4% |
| 2 | 44908 | 1.9% |
| Other values (676) | 434547 |
| Value | Count | Frequency (%) |
| 1 | 43481 | 1.8% |
| 2 | 44908 | 1.9% |
| 3 | 90988 | 3.8% |
| 4 | 129921 | 5.5% |
| 5 | 160343 | 6.8% |
| 6 | 499448 | |
| 7 | 26913 | 1.1% |
| 8 | 42514 | 1.8% |
| 9 | 55971 | 2.4% |
| 10 | 99799 | 4.2% |
| Value | Count | Frequency (%) |
| 3816 | 1 | |
| 2425 | 1 | |
| 2159 | 1 | |
| 2055 | 1 | |
| 1920 | 1 | |
| 1910 | 1 | |
| 1896 | 1 | |
| 1800 | 2 | |
| 1793 | 1 | |
| 1763 | 1 |
Dollars
Real number (ℝ)
High correlation Skewed
| Distinct | 33567 |
|---|---|
| Distinct (%) | 1.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 135.68147 |
| Minimum | 0 |
|---|---|
| Maximum | 50175.7 |
| Zeros | 153 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 18.1 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 23.8 |
| Q1 | 49.26 |
| median | 83.93 |
| Q3 | 140.52 |
| 95-th percentile | 377.76 |
| Maximum | 50175.7 |
| Range | 50175.7 |
| Interquartile range (IQR) | 91.26 |
Descriptive statistics
| Standard deviation | 281.66494 |
|---|---|
| Coefficient of variation (CV) | 2.0759278 |
| Kurtosis | 2321.0212 |
| Mean | 135.68147 |
| Median Absolute Deviation (MAD) | 40.85 |
| Skewness | 30.428901 |
| Sum | 3.2190077 × 108 |
| Variance | 79335.139 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 39.96 | 7595 | 0.3% |
| 63.12 | 7404 | 0.3% |
| 85.68 | 6978 | 0.3% |
| 78.36 | 6320 | 0.3% |
| 72.84 | 5885 | 0.2% |
| 73.44 | 5573 | 0.2% |
| 71.4 | 5408 | 0.2% |
| 78.84 | 5323 | 0.2% |
| 55.2 | 5102 | 0.2% |
| 134.28 | 5088 | 0.2% |
| Other values (33557) | 2311798 |
| Value | Count | Frequency (%) |
| 0 | 153 | |
| 0.36 | 7 | < 0.1% |
| 0.38 | 11 | < 0.1% |
| 0.62 | 13 | < 0.1% |
| 0.64 | 6 | < 0.1% |
| 0.71 | 112 | |
| 0.72 | 74 | |
| 0.73 | 35 | < 0.1% |
| 0.74 | 92 | |
| 0.75 | 40 | < 0.1% |
| Value | Count | Frequency (%) |
| 50175.7 | 1 | |
| 39503.25 | 1 | |
| 38949.9 | 1 | |
| 36517.35 | 1 | |
| 35506.82 | 1 | |
| 32465.68 | 1 | |
| 32445.54 | 1 | |
| 31473.31 | 1 | |
| 30578.28 | 1 | |
| 30534.79 | 1 |
Classification
Categorical
High correlation
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 113.1 MiB |
| 1 | |
|---|---|
| 2 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1 |
|---|---|
| 2nd row | 1 |
| 3rd row | 1 |
| 4th row | 1 |
| 5th row | 1 |
Common Values
| Value | Count | Frequency (%) |
| 1 | 1320234 | |
| 2 | 1052240 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 1 | 1320234 | |
| 2 | 1052240 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 1320234 | |
| 2 | 1052240 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 2372474 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 1 | 1320234 | |
| 2 | 1052240 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 2372474 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 1 | 1320234 | |
| 2 | 1052240 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 2372474 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 1 | 1320234 | |
| 2 | 1052240 |
Interactions
Correlations
| Brand | Classification | Dollars | PONumber | PurchasePrice | Quantity | Store | VendorNumber | |
|---|---|---|---|---|---|---|---|---|
| Brand | 1.000 | 0.819 | -0.258 | 0.010 | -0.433 | 0.104 | 0.037 | -0.031 |
| Classification | 0.819 | 1.000 | 0.013 | 0.017 | 0.005 | 0.008 | 0.063 | 0.071 |
| Dollars | -0.258 | 0.013 | 1.000 | 0.036 | 0.559 | 0.588 | 0.038 | 0.057 |
| PONumber | 0.010 | 0.017 | 0.036 | 1.000 | 0.019 | 0.020 | 0.018 | -0.007 |
| PurchasePrice | -0.433 | 0.005 | 0.559 | 0.019 | 1.000 | -0.257 | 0.038 | 0.069 |
| Quantity | 0.104 | 0.008 | 0.588 | 0.020 | -0.257 | 1.000 | 0.006 | 0.001 |
| Store | 0.037 | 0.063 | 0.038 | 0.018 | 0.038 | 0.006 | 1.000 | 0.002 |
| VendorNumber | -0.031 | 0.071 | 0.057 | -0.007 | 0.069 | 0.001 | 0.002 | 1.000 |
Missing values
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
Sample
| InventoryId | Store | Brand | Description | Size | VendorNumber | VendorName | PONumber | PODate | ReceivingDate | InvoiceDate | PayDate | PurchasePrice | Quantity | Dollars | Classification | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 69_MOUNTMEND_8412 | 69 | 8412 | Tequila Ocho Plata Fresno | 750mL | 105 | ALTAMAR BRANDS LLC | 8124 | 2023-12-21 | 2024-01-02 | 2024-01-04 | 2024-02-16 | 35.71 | 6 | 214.26 | 1 |
| 1 | 30_CULCHETH_5255 | 30 | 5255 | TGI Fridays Ultimte Mudslide | 1.75L | 4466 | AMERICAN VINTAGE BEVERAGE | 8137 | 2023-12-22 | 2024-01-01 | 2024-01-07 | 2024-02-21 | 9.35 | 4 | 37.40 | 1 |
| 2 | 34_PITMERDEN_5215 | 34 | 5215 | TGI Fridays Long Island Iced | 1.75L | 4466 | AMERICAN VINTAGE BEVERAGE | 8137 | 2023-12-22 | 2024-01-02 | 2024-01-07 | 2024-02-21 | 9.41 | 5 | 47.05 | 1 |
| 3 | 1_HARDERSFIELD_5255 | 1 | 5255 | TGI Fridays Ultimte Mudslide | 1.75L | 4466 | AMERICAN VINTAGE BEVERAGE | 8137 | 2023-12-22 | 2024-01-01 | 2024-01-07 | 2024-02-21 | 9.35 | 6 | 56.10 | 1 |
| 4 | 76_DONCASTER_2034 | 76 | 2034 | Glendalough Double Barrel | 750mL | 388 | ATLANTIC IMPORTING COMPANY | 8169 | 2023-12-24 | 2024-01-02 | 2024-01-09 | 2024-02-16 | 21.32 | 5 | 106.60 | 1 |
| 5 | 5_SUTTON_3348 | 5 | 3348 | Bombay Sapphire Gin | 1.75L | 480 | BACARDI USA INC | 8106 | 2023-12-20 | 2024-01-02 | 2024-01-12 | 2024-02-05 | 22.38 | 6 | 134.28 | 1 |
| 6 | 1_HARDERSFIELD_8358 | 1 | 8358 | Bacardi 151 Proof | 750mL | 480 | BACARDI USA INC | 8106 | 2023-12-20 | 2024-01-01 | 2024-01-12 | 2024-02-05 | 14.49 | 12 | 173.88 | 1 |
| 7 | 30_CULCHETH_4903 | 30 | 4903 | Bacardi Superior Rum | 200mL | 480 | BACARDI USA INC | 8106 | 2023-12-20 | 2024-01-01 | 2024-01-12 | 2024-02-05 | 2.87 | 48 | 137.76 | 1 |
| 8 | 34_PITMERDEN_3782 | 34 | 3782 | Grey Goose Le Citron Vodka | 750mL | 480 | BACARDI USA INC | 8106 | 2023-12-20 | 2024-01-02 | 2024-01-12 | 2024-02-05 | 18.89 | 5 | 94.45 | 1 |
| 9 | 1_HARDERSFIELD_4233 | 1 | 4233 | Castillo Silver Label Rum | 1.75L | 480 | BACARDI USA INC | 8106 | 2023-12-20 | 2024-01-01 | 2024-01-12 | 2024-02-05 | 7.87 | 23 | 181.01 | 1 |
| InventoryId | Store | Brand | Description | Size | VendorNumber | VendorName | PONumber | PODate | ReceivingDate | InvoiceDate | PayDate | PurchasePrice | Quantity | Dollars | Classification | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2372464 | 79_BALLYMENA_19556 | 79 | 19556 | Zorvino Bacca Z Blackberry | 750mL | 90058 | ZORVINO VINEYARDS | 13593 | 2024-12-19 | 2024-12-31 | 2025-01-09 | 2025-02-06 | 9.39 | 12 | 112.68 | 2 |
| 2372465 | 69_MOUNTMEND_25125 | 69 | 25125 | Zorvino Vyds Mango Magnifico | 750mL | 90058 | ZORVINO VINEYARDS | 13593 | 2024-12-19 | 2024-12-30 | 2025-01-09 | 2025-02-06 | 8.55 | 11 | 94.05 | 2 |
| 2372466 | 69_MOUNTMEND_19556 | 69 | 19556 | Zorvino Bacca Z Blackberry | 750mL | 90058 | ZORVINO VINEYARDS | 13593 | 2024-12-19 | 2024-12-30 | 2025-01-09 | 2025-02-06 | 9.39 | 12 | 112.68 | 2 |
| 2372467 | 79_BALLYMENA_19557 | 79 | 19557 | Zorvino Fragole Z Strawberry | 750mL | 90058 | ZORVINO VINEYARDS | 13593 | 2024-12-19 | 2024-12-31 | 2025-01-09 | 2025-02-06 | 9.39 | 11 | 103.29 | 2 |
| 2372468 | 67_EANVERNESS_25126 | 67 | 25126 | Zorvino Vyds Peachez | 750mL | 90058 | ZORVINO VINEYARDS | 13593 | 2024-12-19 | 2024-12-28 | 2025-01-09 | 2025-02-06 | 6.62 | 11 | 72.82 | 2 |
| 2372469 | 49_GARIGILL_22298 | 49 | 22298 | Zorvino Vyds Sangiovese | 750mL | 90058 | ZORVINO VINEYARDS | 13593 | 2024-12-19 | 2024-12-28 | 2025-01-09 | 2025-02-06 | 8.06 | 12 | 96.72 | 2 |
| 2372470 | 1_HARDERSFIELD_19556 | 1 | 19556 | Zorvino Bacca Z Blackberry | 750mL | 90058 | ZORVINO VINEYARDS | 13593 | 2024-12-19 | 2024-12-27 | 2025-01-09 | 2025-02-06 | 9.39 | 12 | 112.68 | 2 |
| 2372471 | 66_EANVERNESS_22297 | 66 | 22297 | Zorvino Vyds Pearz | 750mL | 90058 | ZORVINO VINEYARDS | 13593 | 2024-12-19 | 2024-12-26 | 2025-01-09 | 2025-02-06 | 6.75 | 12 | 81.00 | 2 |
| 2372472 | 69_MOUNTMEND_19557 | 69 | 19557 | Zorvino Fragole Z Strawberry | 750mL | 90058 | ZORVINO VINEYARDS | 13593 | 2024-12-19 | 2024-12-26 | 2025-01-09 | 2025-02-06 | 9.39 | 12 | 112.68 | 2 |
| 2372473 | 55_DRY GULCH_22298 | 55 | 22298 | Zorvino Vyds Sangiovese | 750mL | 90058 | ZORVINO VINEYARDS | 13593 | 2024-12-19 | 2024-12-28 | 2025-01-09 | 2025-02-06 | 8.06 | 12 | 96.72 | 2 |